﻿CREATE TABLE [dbo].[EntityProperty]
(
	[entity_property_id] INT NOT NULL  IDENTITY, 
    [entity_type_property_id] INT NOT NULL, 
	[entity_id] INT NOT NULL,
    [string_value] VARCHAR(256) NOT NULL, 
    [base_type] VARCHAR(128) NOT NULL, 
    [int_value] INT NULL, 
    [double_value] FLOAT NULL, 
    [datetime_value] DATETIME NULL, 
    [bigint_value] BIGINT NULL, 
    CONSTRAINT [PK_EntityProperty] PRIMARY KEY ([entity_property_id]))
